From Cooperative Scans to Predictive Buffer Management

In analytical applications, database systems often need to sustain workloads with multiple concurrent scans hitting the same table. The Cooperative Scans (CScans) framework, which introduces an Active Buffer Manager (ABM) component into the database architecture, has been the most effective and elaborate response to this problem, and was initially developed in the X100 research prototype. We now report on the the experiences of integrating Cooperative Scans into its industrial-strength successor, the Vectorwise database product. During this implementation we invented a simpler optimization of concurrent scan buffer management, called Predictive Buffer Management (PBM). PBM is based on the observation that in a workload with long-running scans, the buffer manager has quite a bit of information on the workload in the immediate future, such that an approximation of the ideal OPT algorithm becomes feasible. In the evaluation on both synthetic benchmarks as well as a TPC-H throughput run we compare the benefits of naive buffer management (LRU) versus CScans, PBM and OPT; showing that PBM achieves benefits close to Cooperative Scans, while incurring much lower architectural impact.Comment: VLDB201

Poplar maintains zinc homeostasis with heavy metal genes HMA4 and PCS1

Perennial woody species, such as poplar (Populus spp.) must acquire necessary heavy metals like zinc (Zn) while avoiding potential toxicity. Poplar contains genes with sequence homology to genes HMA4 and PCS1 from other species which are involved in heavy metal regulation. While basic genomic conservation exists, poplar does not have a hyperaccumulating phenotype. Poplar has a common indicator phenotype in which heavy metal accumulation is proportional to environmental concentrations but excesses are prevented. Phenotype is partly affected by regulation of HMA4 and PCS1 transcriptional abundance. Wild-type poplar down-regulates several transcripts in its Zn-interacting pathway at high Zn levels. Also, overexpressed PtHMA4 and PtPCS1 genes result in varying Zn phenotypes in poplar; specifically, there is a doubling of Zn accumulation in leaf tissues in an overexpressed PtPCS1 line. The genomic complement and regulation of poplar highlighted in this study supports a role of HMA4 and PCS1 in Zn regulation dictating its phenotype. These genes can be altered in poplar to change its interaction with Zn. However, other poplar genes in the surrounding pathway may maintain the phenotype by inhibiting drastic changes in heavy metal accumulation with a single gene transformation

Concentrations of potentially toxic elements and soil environmental quality evaluation of a typical Prosecco vineyard of the Veneto region (NE Italy)

Purpose The aim of this work was to assess the concentrations of potentially toxic elements and to evaluate the soil quality of a typical Prosecco Denomination of Controlled and Guaranteed Origin vineyard of the Veneto region, NE Italy. Materials and methods Soil samples and leaves of Taraxacum officinale and Vitis vinifera were collected during spring–summer 2014. Element determination (Al, Cd, Cr, Cu, Fe, Mg, Mn, Ni, P, Pb, V, and Zn) were performed with ICP-OES after microwave digestion of samples. Soil quality was assessed via the biological soil quality (BSQ-ar) index. Lipid peroxidation test was performed to evaluate the vegetation oxidative stress, based on malondialdehyde (MDA) content via spectrophotometer. Results and discussion High concentrations of Al,Mg, and P were identified in soil, while high contents of Al, Cu, Fe, and Zn were found in V. vinifera leaves. The high concentrations in soil are probably due to agricultural activities, whereas those in leaves are probably due to atmospheric deposition and repeated use of foliar sprays in viticulture. The bioconcentration factor showed an effective transport of Cu, P, and Zn, from soil to leaf. The BSQ-ar values registered were similar to those obtained in preserved soils; hence, the biological class (VI) of these soils is high. The MDA content in T. officinale and V. vinifera leaves was below the reference value for T. officinale (2.9 ± 0.2 μM), suggesting that the metal content did not stress the vegetation in the investigated site. Conclusions The MDA value for V. vinifera (1.1 ± 0.7 μM) could be adopted as another control value for soil quality, which in our case is of Bgood quality.^ Moreover, our results suggest that high concentrations of elements detected in the analyzed samples do not influence negatively the quality of soil, but a better agronomic management could improve soil quality in the studied area

Development of a System for Supervised Training at Home with Kinect V2

AbstractTherapy of injured professional and amateur sportsmen can take long periods of time. It is important to promote sustained motivation during long rehabilitation phases. Live feedback and playful applications enhance the compliance of users. For this project the newest version of the Microsoft Kinect sensor (Kinect v2) was used and implemented into a prototype for supervised rehabilitation of injured athletes. A playful approach combined with a proper gamification concept ensures a constant high level of motivation for athletes of all ages recovering from injuries